Computer Science Lesson Plan
Class: 5 - Lesson: 6.2 Spreadsheet (Create a Student Mark Sheet)

Purpose: Students should learn the special features of spreadsheets - freezing rows and columns, and Find and Replace.

No. of Classes

One or two classes (teacher's decision).

Material Required

OpenOffice (Spreadsheet).

Curriculum Content
  • 7) Open office - Spread sheet
  • 7.1) Spread sheet basics
  • 7.2) Cell properties
  • 7.2.14) Find, replace
  • 7.2.17) Freeze rows and columns
  • 7.2.18) Sort sheet by columns
    •

    Prior Knowledge

    Students should know:

  • The basics of spreadsheets.

    • Exercise

    Exercise 1


    1. Create a new spreadsheet and name it 'student mark sheet.ods'. Use formulae to calculate the Total and Average.

    Exercise 2


    1. How do you sort and freeze rows and columns in a spreadsheet?

    Exercise 3


    1. How do you find and replace words?

    Solution


  • Link to copy the solution spreadsheet.
  • Link to view the solution video for Exercise 1.
  • Link to view the solution video for Exercise 2.
  • Link to view the solution video for Exercise 3.

    • Teacher Instructions
    1. Teachers should ensure that students understand simple operations such as addition, subtraction, multiplication and division before giving the exercise.
    2. Students should identify the number of rows and columns before creating the spreadsheet.
    3. Teachers should explain the autofill feature (drag the autofill handle at the bottom right of a cell) and how this is useful in filling dates, days or serial numbers.
    4. Teachers should ensure that all students understand the freeze rows and columns feature and how to sort columns, and also how to highlight the header row by applying shading to that row.
    5. To find the formula in a specific cell, refer to the formula bar at the top left of the sheet.